package com.zwcloud.zw.railway.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zwcloud.zw.railway.entity.CcxxallEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CcxxallMapper extends BaseMapper<CcxxallEntity> {

    /**
     * 根据批次信息查询总车皮数
     *
     * @param cpxxPici 批次信息
     * @return 总车皮数
     */
    @Select("SELECT ccxxall.ccxx_checi FROM ccxxall WHERE ccxxall.ccxx_Pici = #{cpxxPici}")
    Integer selectCcxxCheciByCpxxPici(@Param("cpxxPici") String cpxxPici);
}